package com.product.dao;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.product.entity.EquityDetailed;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.time.LocalDateTime;
import java.util.List;

/**
 * 权益详细表(EquityDetailed)表数据库访问层
 *
 * @author 刘童
 * @since 2024-06-18 15:07:34
 */
@Mapper
public interface EquityDetailedDao extends BaseMapper<EquityDetailed> {
    @Select("SELECT * FROM equity_detailed WHERE time_off BETWEEN #{startDateTime} AND #{endDateTime}")
    List<EquityDetailed> findEquityExpiringBetween(@Param("startDateTime") LocalDateTime startDateTime, @Param("endDateTime") LocalDateTime endDateTime);

}

